package com.zjitc.backend_shop.mapper;

import org.apache.ibatis.annotations.Select;

import java.util.List;

/*
    @author： 尤安托
    @date： 2025/4/23 15:52
*/
public interface MenuMapper{
    @Select("select distinct pattern_url from `t_authority_menu` t1\n" +
            "\tinner join `t_authority_role_menu` t2 on t2.`m_id`=t1.`id`\n" +
            "\tinner join `t_authority_role` t3 on t3.`id` = t2.`r_id`\n" +
            "\tinner join `t_authority_role_user` t4 on t4.`r_id`=t3.`id`\n" +
            "\tinner join `t_authority_user` t5 on t5.`id`=t4.`u_id`\n" +
            "where t5.username=#{username}")
    public List<String> findtest(String username);
}
